Jerry Mitchell's revival of his 2005 Broadway musical opens in Manchester ahead of its West End transfer