Greater Manchester mayor says he wants to contest a by-election and return to Westminster