Confidence among UK consumers saw an improvement in September, rebounding to pre-Brexit levels last seen in June, according to new figures.