You wouldnt have to pay for the remainder of the policy as you are then technically insuring a car up until the point of renewal which is illegal as the car is no longer in existance.
You should be able to either change the vehicle on the policy to a new one, or cancel with effect from now, but you may have to pay a cancellation charge - this is normally mentioned in the policy booklet.