Small business confidence has returned to levels last seen before June’s referendum, reversing the negative sentiment that followed the vote to leave the European Union.