MySQL query with increment based on already existing values and only in rows with collum "Confirmed" not zero : I have a table that is manually edited from a webstore.

I would like to do this faster with a query.

Table: Orders

I would like to auto increment collum 'Invoice number' in all rows  if collum 'status id' (is not zero / 1-5)

And i would like to start from a ceratain row (The next row after last manual input)