Brian Thompson led one of the biggest health insurers in the US before he was shot dead in an apparent targeted killing in Manhattan.