A tornado has caused widespread damage in a small town in north-eastern Germany, ripping off most of a church roof and covering streets in debris.