Mapping similar products in single product in price comparison website
The basics you can do with a simple GROUP BY:

select
 title,
 group_concat(id) as brandIDs
from product1
group by title;


http://sqlfiddle.com/#!9/87532/1

But it will group only products with exactly the same title, no way to simply say in SQL that Samsung Galaxy Ace Nxt G313H Black and Samsung Galaxy Ace Nxt G313H White are the same.

You should normalize your table. You can use a separate table of brands which will save space from the multiplication of the names. And you can add some "hierarchy" of brand->series->product like Samsung->Galaxy Ace Nxt->G313H Black to make these queries easier.

Edit:
I tried to get exactly the results you show with MySQL string functions:

select
 substring_index(title,' ',4),
 group_concat(id) as brandIDs
from product1
group by substring_index(title,' ',4);


http://sqlfiddle.com/#!9/87532/6