Answer:   By default test class cannot recognize the existing data in the database.
If you mention @is Test(seeAllData = true) then test class can recognize the existing data in the database.
From a List Custom setting we cannot fetch the existing data without seeAllData = true in test class.