Exclusive: Campaigners said Labour had to ‘catch up with public opinion’ as PM faces calls for closer ties to the EU after Brexit