Generate consecutive id number with annual restart in PHP

<?php
session_start();
/* Inicia validacion del lado del servidor */
if (empty($_POST['sheets'])) {
    $errors[] = "Hojas vacío";
} else if (empty($_POST['title'])) {
    $errors[] = "Asunto vacío";
} else if (
        !empty($_POST['sheets']) &&
        !empty($_POST['title'])
) {

    include "../config/config.php"; //Contiene funcion que conecta a la base de datos        

    $title = $_POST["title"];
    $description = $_POST["description"];
    $sender_id = $_POST["sender_id"];
    $kind_id = $_POST["kind_id"];
    $user_id = $_SESSION["user_id"];
    $project_id = $_POST["project_id"];
    $category_id = $_POST["category_id"];
    $priority_id = $_POST["priority_id"];
    $status_id = $_POST["status_id"];
    $attach_id = $_POST["attach_id"];
    $hojas = $_POST["sheets"];
    $created_at = "NOW()";
//                $asigned_id = $_SESSION["asigned_id"];          
//                $publico = $_POST["publico"];
    // $user_id=$_SESSION['user_id'];

    $sql = "insert into document (title,description,sender_id,kind_id,user_id,project_id,category_id,priority_id,status_id,attach_id,sheets,created_at) value (\"$title\",\"$description\",\"$sender_id\",$kind_id,$user_id,\"$project_id\",\"$category_id\",$priority_id,$status_id,$attach_id,$hojas,$created_at)";

    $query_new_insert = mysqli_query($con, $sql);
    if ($query_new_insert) {
        $messages[] = "Tu documento ha sido ingresado satisfactoriamente.";
    } else {
        $errors [] = "Lo siento algo ha salido mal intenta nuevamente." . mysqli_error($con);
    }
} else {
    $errors [] = "Error desconocido.";
}

if (isset($errors)) {
    ?>
  <div class="alert alert-danger" role="alert">
    <button type="button" class="close" data-dismiss="alert">&times;</button>
    <strong>Error!</strong>
    <?php
        foreach ($errors as $error) {
            echo $error;
        }
        ?>
  </div>
  <?php
}
if (isset($messages)) {
    ?>
    <div class="alert alert-success" role="alert">
      <button type="button" class="close" data-dismiss="alert">&times;</button>
      <strong>¡Bien hecho!</strong>
      <?php
        foreach ($messages as $message) {
            echo $message;
        }
        ?>
    </div>
    <?php
}
?>