Consecutive in PHP and MySQL

Good day I have a table in mysql called "def_consecutivo"

where there is a field id

iddef_consecutivo | desde | hasta | contador

• the id is a field to identify ranges
• desde is for the start of the range of numbers
• hasta for end of range
• contador for the data counter that should be increased

I want to do a function in php that helps me see and insert the next consecutive in the field if the added data is within the corresponding range