No. You do not need to pay vehicle tax if your car, van, motorcycle, or tricycle is more than 40 years old, on a rolling basis, unless it is used for hire or reward or for commercial purposes.
Unlike the MOT exemption for vehicles more than 40 years old, which applies automatically, you must apply for vehicle tax exemption.