‘If we stick together, we will get through it’ Nicola Sturgeon makes emotional plea to follow new restrictions