After getting ‘the tap’ at Cambridge, he went from a behind-the-scenes TV ideas man to a fixture in front of the camera. Then the Pointless star’s Thursday Murder Club books became the biggest thing in fiction since Harry Potter