I love this song too. My husband and I have been involved in a town twinning arrangement between Linlithgow in West Lothian, and Guyancourt, near Versailles. Music is a big part of any of our twinning weekends, and I introduced this song to our French friends, so we sing an extended bi-lingual version, 3 in French as above, and 3 in English translation.
Oddly enough, the French musicians said they did not know the song and protested a bit, " Of course, we are not Normans!" they said! It seemed that more of the Scots knew it, again from French lessons at school!