fix: #3617897 Reset the serial ID of a table when it is emptied

Francesco Placellarequested to merge
issue/drupal-3617897:3617897-truncate-resets-serial-id into main

Closes #3617897

Merge request reports