Nearly nine-in-10 Scots say they must shop local to ensure high streets thrive