Welcome to the Mudcat Susanne,There have been multiple discussions of this song and its variants. You can click here, or here, or here, or here.
The first one has a posting by Bruce O. that may answer your Scottish version question. There are also some suggested ways to search for variants in the DT that may help you.
Enjoy the song! Impress your friend!
Roger in Baltimore