New survey reveals almost three-quarters of Scottish SMEs are confident about their future