David Beckham has called it "truly humbling" and an "emotional moment" to be made a knight in the King's Birthday Honours.