Neighbours have been left in "shock" and fear after the sudden deaths of a popular British couple in rural France.