A Conservative amendment saying the Scottish Government should respect the result of the UK-wide EU referendum and rule out a second independence referendum was defeated by 92 votes to 31, with one abstention.