Update row which depend on previous row value MySQL

Question

I have a table where some column value depend on previous column value.
Here is table sample data.

+----+--------+----------+--------------+--------------+
| ID | Demand | Arriaval | OpeningStock | ClosingStock |
+----+--------+----------+--------------+--------------+
|  1 |      0 |      200 |            0 |          200 |
|  2 |     50 |        0 |          200 |          150 |
|  3 |     50 |      100 |          150 |          200 |
|  4 |    100 |      300 |          200 |          400 |
+----+--------+----------+--------------+--------------+

You can see openingStock is previous closingStock. And closing stock is calculated as

Arrival + OpeningStock - Demand = ClosingStock

If I change any closingStock then I have to update all next rows.
For example if I change row id=1 closingStock then I have to update all next three rows. I have thousand of row everytime I need to update single record I have to update all next records.

Is there any kind of pointer in mysql we can point opening stock to previous closing stock.

Or is there anything which can update automatically all next records when I row cloasing stock is updated