MSSQL:

SELECT CONCAT('MIG-T-',FORMAT(1, '000000'));

MYSQL:

SELECT CONCAT('MIG-T-',LPAD(1,5,0));