Restrictions imposed by Nicola Sturgeon to contain the spread of Covid in Scotland were largely ignored by the public, a study suggests.