The correct saying is: "I was born on 18 August 2006."
When stating a specific date, such as a birthday, you use the preposition "on" to indicate the day of the month on which the event occurred. So, you would say "on 18 August 2006" to indicate that your birth occurred on that particular date.