如何解决这个提供奇数的mysql唯一id？

DELIMITER //
CREATE FUNCTION generate_odd_id() RETURNS INT
BEGIN
  DECLARE id INT;
  SET id = (SELECT MAX(id) FROM your_table);
  IF id IS NULL THEN
    SET id = 1;
  ELSE
    SET id = id + 2;
  END IF;
  RETURN id;
END //
DELIMITER ;

INSERT INTO your_table (id, column1, column2) VALUES (generate_odd_id(), value1, value2);

CREATE TRIGGER generate_odd_id_trigger BEFORE INSERT ON your_table
FOR EACH ROW
BEGIN
  DECLARE id INT;
  SET id = (SELECT MAX(id) FROM your_table);
  IF id IS NULL THEN
    SET NEW.id = 1;
  ELSE
    SET NEW.id = id + 2;
  END IF;
END;

INSERT INTO your_table (column1, column2) VALUES (value1, value2);