"I have never yet seen an Irish tourist in an Edinburgh pub make a request that wasn't something the whole room cringed at. (It's nearly always "Fields of Athenry") "
Your average Scottish punter would probably shout for "Flower of Scotland" or some other such shecht.