In a Singapore exclusive, the actor tells CNA Lifestyle about his advice for the next 007 actor, his most painful stunt