The earliest known coin minted in Scotland – almost 900 years ago – has been acquired for the nation after it was found by a metal detectorist..