UK urged to build relationships with ‘middle powers’ such as Canada and Australia and prepare for lack of US support