Actor said being cast as 007 is ‘honour of a lifetime’