Almost three quarters of Scottish businesses are confident about their prospects next year, a survey has suggested.