Sequencing is probably the hardest part for me since I have a bundle of songs that comprise a suite amongst the rest and there's also a stylistic/sonic development chronologically that my mind insist should, logically, be followed.
....................
Interesting that Ido used the ME to sequqnce. I know they've often done this in the dim dark. How did it go for you Ido?
I think the first 3 songs are usually the ones that will 1.) grab & hold the attention of the listener, so the he/she stays for the remainder, and 2.) those 3 songs set the style/vibe/flow for the rest.
Which songs you pick for the first three and their exact order...is partly personal and partly pseudo-science. Some will say to put your strongest one first....strongest being the one that will have the greatest grab & hold effect.
Others will warm/ramp up to it, and stick it in the 3rd position.
I think it really matters who you are, and who your target audience is.
Like...if you are making CDs as vehicles to sell yourself or your music (or both) to some record company people....then put the best first. Most of them will not listen much past the first 30 seconds if that opening song doesn't really grab & hold them. IOW....put the song that you think will sell the best, 'cuz that's what they are listening for in most cases.
Having someone else (like the ME) do it....might be OK if you are not sure, since they hear a lot of music and will often be able to spot the better songs more objectively.
If you already have a pretty good fan base, and you're just releasing a CD for public consumption, then there's more room for personal/stylistic choices in the song order.
For the majority of home-rec artists self-releasing their CDs without direct pursuit of record company deals, and instead just putting them out for sale on the interwebs, I don't think it matter all that much what song order you choose AFA "selling" goes.
If anyone buys your CD, they will most likely hear the whole thing at least one time, and pick their favorite songs.
If they are trying to decide on buying or not, most interweb sale sites offer samples of each song, so people can click through them....etc....and decide that way.
Apart from trying to promote the CD to a record company....the order is mostly about setting a good listening experience from start to finish, and that can probably be done a few different ways...depending on the style of music and songs you are including. I don't think there's a real "wrong" way...just don't put your "weakest" 2-3 songs at the front.
On my last CD, I think I changed the order a few times...and it also changed as I progressed through the recording/mixing process. Songs kinda shifted their positions as I worked on them.