The British people have shot themselves in the foot by voting for Brexit, billionaire Richard Branson told CNBC on Tuesday.