As London becomes too costly, Manchester – beneficiary of “northshoring” – has emerged as an attractive destination