Nigel Farage could be the next prime minister - but Labour could beat him by connecting with voters more, Greater Manchester's Labour mayor has told Sky News.