In 1851 Roger Moffet states he was born circa 1805 East Ord, thereafter ca.1803 Berwick upon Tweed.
He was apparently baptised United Presbyterian, Spittal, Northumberland (per FindMyPast) although no actual baptism date given - he is shown as:
Roger Moffet, son of Roger Moffet and Elizabeth his wife, of East Ord, parish of Tweedmouth, born 14/5/1802.
plus
George Moffet, ditto, born 21/6/1803
Andrew Moffet, ditto, born 23/9/1804
plus at least 8 others.
Where his parents married I have no idea.
Annette