The majority of Scots say public’s response to the coronavirus crisis has shown the ‘unity of our society more than its divides’