Four women and a man were shot dead at the scene while a sixth person died in hospital, police say.