The heads of the UK, Scottish and Welsh governments came together ahead of the opening of the Glasgow Commonwealth Games.