Manchester has surpassed London as the top city in England for property investment, while demand in Scotland’s largest cities remained particularly strong.