Women, children and elderly people among at least 24 killed by attack that turned beach spot into scene of carnage