For a small town St Andrews is remarkably well known around the world, and it has seen the unfolding of much of Scotland's story. Alan MacDonald reflects.