Given that it’s a non-computed column, the only way that can happen is with an action. Maintaining counters in this way is always problematic and subject to all sorts of things going wrong.
I did offer you an alternative solution to this problem a day or two ago - no interest in that?