Scotland’s chief medic resigns after flouting own 'stay home' advice