Residents in Pembrokeshire were baffled after waking up to find giant dinosaur footprints dotted along their local beach.