Consumer confidence plummeted in its sharpest month-on-month decline in 26 years as shoppers revealed “concern” following the Brexit vote.