Stewie, I think that's another CD! (Alastair has made so many!) The one asked for by the original poster is called "Scotland in Song", not "Songs of Scotland" and the 4th track on that is "Mouth Music", which is what was asked for.
Just had another listen myself to the Mouth Music track: OF COURSE! The first tune is known in English (or Scots) as the Drunken Piper, and here it is in Gaelic, with a very literal translation below:

Far am bi mi fhin
I hope that Hawkes and Saes now pick up on this: as they are Guests I can't pm them!