It has been one of the biggest questions of the showbiz year: who will be the next James Bond?