If a hard Brexit happens it would be pretty devastating and it would be the biggest sort of shot in the foot that the British people have ever done to themselves, so (I) hope that sense will prevail,” he told CNBC.