New polling and recent by-elections signal Britain has turned its back on Brexit, the former minister for Europe Denis MacShane has said.