Horse has to be put down following ‘tragic’ collision with car