Lidl has overtaken The Co-op to become the UK’s sixth largest supermarket as rising inflation leads shoppers to flock to the discounters.