UK retail sales recorded their worst real terms performance in nearly six years during September, with clothing and footwear the worst-performing categories.