Is this normal or is there another way to solve this?

|  4 | Delsa     | Arjay     | E              |

MariaDB [project]> DELETE FROM Student_Name WHERE id=3;
Query OK, 1 row affected (0.005 sec)

MariaDB [project]> select *from student_name;
+----+-----------+------------+----------------+
| id | Last_Name | First_Name | Middle_Initial |
+----+-----------+------------+----------------+
|  1 | Gargar    | Rosales  | F              |
|  2 | florante    | Rosal      | L         |
+----+-----------+------------+----------------+
2 rows in set (0.001 sec)

MariaDB [project]> DELETE FROM Student_Name WHERE id=2;
Query OK, 1 row affected (0.003 sec)

MariaDB [project]> select *from student_name;
+----+-----------+------------+----------------+
| id | Last_Name | First_Name | Middle_Initial |
+----+-----------+------------+----------------+
|  1 | Gargar    | Rosales  | F              |
+----+-----------+------------+----------------+
1 row in set (0.000 sec)

MariaDB [project]> desc student_name;
+----------------+-------------+------+-----+---------+----------------+
| Field          | Type        | Null | Key | Default | Extra          |
+----------------+-------------+------+-----+---------+----------------+
| id             | int(11)     | NO   | PRI | NULL    | auto_increment |
| Last_Name      | varchar(50) | NO   |     | NULL    |                |
| First_Name     | varchar(50) | NO   |     | NULL    |                |
| Middle_Initial | varchar(1)  | NO   |     | NULL    |                |
+----------------+-------------+------+-----+---------+----------------+
4 rows in set (0.006 sec)

MariaDB [project]> insert into student_name (Last_Name, First_Name, Middle_Initial) values ('Delsa', 'Arjay', 'E');
Query OK, 1 row affected (0.002 sec)

MariaDB [project]> DELETE FROM Student_Name WHERE id=2;
Query OK, 0 rows affected (0.001 sec)

MariaDB [project]> select *from student_name;
+----+-----------+------------+----------------+
| id | Last_Name | First_Name | Middle_Initial |
+----+-----------+------------+----------------+
|  1 | Delan     | Rosalinda  | F              |
|  4 | Delsa     | Arjay     | E              |
+----+-----------+------------+----------------+
2 rows in set (0.000 sec)