There is some differences between Plus operator's concatenation and CONCAT() function.
SELECT CONCAT(1, 2, 3, 4) AS IntegersCONCAT
SELECT 1+2+3+4 as IntegersPlusOperation
Plus operator will do the addition operation against the integer operands; where as CONACT considers each operand as Strings
.. so it resulted '1234' as output