Cancelling phase 2 of HS2 would leave north of England with transport network ‘unfit for purpose, say Labour mayors