Brits visiting the beach during the heatwave have been warned of a venomous fish with an "excruciating" sting, which is hiding in the shallows.