Small businesses experience a significant boost to confidence across the UK, but overall levels of confidence in Scotland are still below the UK average.