Two houses in Chester have been destroyed after a tractor pulling a wagon full of farm slurry ploughed into them.