Store visits hit their highest level since March 2020 as consumer confidence returned, research suggests.