Scottish golfer Sandy Lyle has said being made an OBE is the “icing on the cake” at the end of a decades-long career.