Only seen them once and lived in Aberdeen and Edinburgh most of my life (also live near Durham now). I’d be willing to bet that 90% (picked out of the air) of Scots have never seen them. Don’t remember speaking to anyone who has.
My one sighting was at the top of a big hill in Aberdeen. Very clear early morning Winter sky, about 5a.m.
And it wasn’t anything like the spectacular photos and videos I’ve seen – just a shimmering and slight undulation – didn’t realise what it had been until I mentioned it to my folks over breakfast. Still beautiful though.
Oh, and also spent a lot of time in the NW of Scotland, and my folks live on Skye – so far as I know they’ve never seen them, but it’s rare to get a clear sky on the west coast 😉