The collision on Vicars Cross Road in Chester saw a tractor colliding with the front of two houses