At my mother's funeral we had "Now thank we all our God": the words are so appropriate for celebrating someone's life rather than mourning their death. The organist also played a selection of her favourite Scottish tunes, including some that had rather hilarious personal stories attached, which some of the congregation wouldn't have known, but we as the family did. My dad requested "Highland Cathedral" which is another amazing pipe tune, now usually played at any public occasion where there are pipe bands.