Slow Horses creator Mick Herron has won the highest accolade for crime writers after coming up with a tale about failing and chaotic spies.