Edit: Whoops. I just realized that the thread topic is about song ORDER, as in, the ordering of tracks on an album. I mistook this for ordering WITHIN a song. My bad. Original post follows, but is blatantly off topic.

MAN, do I feel silly, now.
End edit
On two different occasions, I wrote up a "paper" of sorts about chords and chord progressions, and how they can tell a story that has as much meaning as the lyrics of a song. Neither occasion's paper survived - bad timings of hard disk failure and server problems, etc.
It was quite theory intensive and time consuming to write... basically it focused on how each chord (relative to the key) had its own emotional character (I being complete, V being anticipatory, IV being hopeful, etc) and how these chords strung in a row could let a story unfold.
In all my compositions so far, chord progressions and manipulation has been my forte. I stick mainly to instrumentals because quite frankly, 5-year-olds could write better lyrics than I can, and I sing like a horse with bad dentures. So, since my music usually has little-to-no lyrical content, I rely on other things to pique interest. Transpositions, etc can really bring out the story and add some emotional impact to the chords being used.
One example of transpositions in play:
http://falkon2.mendelsohn.de/Littlefanfare.mp3
This I did almost a year ago, when I first got really interested in tracking my own music. There are a couple of interesting transpositions later on in the track, and I think it showcases the use of certain chord progressions very well. It was done on a poor midi interface and the guitars were a Danelectro Daddy-O right into the soundcard input. (Ouch) I actually want to revisit this song and use some better sounding samples for the midi instrumentation, and the PODxt for the guitar parts.

The most moving songs are those where the music adds to the impact by underscoring the moods delivered by the words.
Ooh, one name that instantly comes to mind when we're talking about moods via sheer music alone is John Williams. A lot of the Star Wars music (especially Episode 5 stuff) was really well written. Atonal, modal, stuff with a solid key - everything flowed together to portray the emotions presented in the movie.