In this "please say again" usage, this is (southern) British English, idiomatic, and not at all intended as offensive, in my experience. All it means is "I didn't understand ; please repeat." From a similar cultural background, "you what?" has similar meaning and often more aggressive or rude intent.