An offshore earthquake of magnitude 6.9 has jolted a central Philippine province and collapsed the walls of houses and buildings, killing at least 31 people.