Pierce Brosnan - who played James Bond between 1994 and 2005 - thinks it would be "exhilarating" to have a female Bond.