How to organize the items by incrementing their id? (SQLite)

I have a table to an application. The application can add a few objects such as blue, red and yellow. Since the items can be added more than once, I wan the items to be added as blue1 for the first time and blue2, blue3 if user keeps on adding blue to identify each blue item.

I thought of giving them an increment id, but then there are red and yellow too.

How to do this?