The Mayor of Greater Manchester said he thought leaving with a deal would be in the 'public interest'