BUG: pandas.read_csv with no schema gives corrupted data
- [x] I have checked that this issue has not already been reported.

- [x] I have confirmed this bug exists on the latest version of pandas.

- [ ] (optional) I have confirmed this bug exists on the master branch of pandas.

---

#### Code Sample, a copy-pastable example

![image](https://user-images.githubusercontent.com/6995213/129669430-27507e05-b8a6-4c24-934e-7945889b41be.png)


```python
x = []
with open(file=fn) as text:
  for line in text.readlines():
    if line.startswith('000651,') or line.startswith('651,'):
      x.append(line)
dat = pd.read_csv(fn)
a = dat[dat['Id'] == '000651']
b = dat[dat['Id'] == 651]
```

#### Problem description

For very long csv file that I'm storing [here](https://mam-dev-khoa.s3.amazonaws.com/dummy.csv?AWSAccessKeyId=ASIA4TCV2CZ7FAE5OWBX&Signature=uX4%2FFIlESZ6v2%2BkoAU3Unz3iQ7s%3D&x-amz-security-token=FwoGZXIvYXdzEFcaDF5jyItKd0DwMh24wyKGAV454HK0YLObdSMHNseu4s96fpjBhy%2FRscSJFnFtCQtanim8mdia5vOKK4StoduCn1J%2FGoz%2F51zOVlUWWQ0e040v37nIkQDQzF7W2xEbqPNr0l4sLgzvdWUWX1R7hcGl8NA1SAvDhUiSEIBzNh6pgHk7%2FW4mXC1lCRlD2qk7boeAYNLi0PsoKO%2Ba7YgGMiijonJs5bU0s%2FhSCVsCThaPb%2BXtZD24DSMCiYaPCbpl1niY0ZKUUKt8&Expires=1629183449), the parser read some of the rows with `Id` as Integer then later some as strings. This leads to corrupted data when we later write the data in memory to SQL.

#### Expected Output

Consistent data type for each column or throw error

#### Output of ``pd.show_versions()``

<details>

INSTALLED VERSIONS
------------------
commit           : f00ed8f47020034e752baf0250483053340971b0
python           : 3.7.9.final.0
python-bits      : 64
OS               : Windows
OS-release       : 10
Version          : 10.0.19041
machine          : AMD64
processor        : Intel64 Family 6 Model 85 Stepping 7, GenuineIntel
byteorder        : little
LC_ALL           : None
LANG             : None
LOCALE           : None.None
pandas           : 1.3.0
numpy            : 1.21.2
pytz             : 2021.1
dateutil         : 2.8.2
pip              : 21.1.3
setuptools       : 57.4.0

</details>
