Almost seven years and four prime ministers since the U.K. voted to leave the European Union, polling suggests public sentiment has turned against Brexit.