UPDATE table SET col = LPAD(col, 6, '0');

CREATE TABLE table1 (
  number INT(6) ZEROFILL DEFAULT NULL
);

INSERT INTO table1 VALUES(1);
SELECT * FROM table1;
+--------+
| number |
+--------+
| 000001 |
+--------+