I just had a think about this and thought of a few examples:
The Beatles - Help (Opener: Help!)
Sting - Mercury falling (Opener: Hounds of winter)*
The Whitlams - Torch the moon (Opener: Cries too much)
Bonus points where the opening song is not also the title track (like the Sting and Whitlams examples).
I'm sure there are many others but they are the initial ones I thought of.
*The Sting one gets bonus points because the closing track ends with the words "Mercury falling" as well, bookending the album nicely :-)