It can happen. I think the key is to be consistent with seeing that person and also making sure to hang out when sober as well (drunk goggles are real)
It will require you to step out of your comfort zone a bit -- you will have to make the moves to show that you want a deeper relationship and not a one-night stand. Or even just a friendship in general.
I bonded with my boyfriend by going to the same parties as him (we are in college) we also talked a lot while sober through mutual friends. It could've been one convo that went well and didnt lead to anything, but eventually we would each make effort to talk to each other at some point if we went to the same party.
If you wanna meet people without the influence of alcohol, you can try dating apps (tho be aware most people will not be looking for anything serious on Bumble or Tinder for example) or casual group activities. If you live near a library or museum, sometimes they will hold casual activity events. If you're more sporty you could find hiking groups or club sports in your area. The key is really consistency -- seeing someone regularly helps with bonding and familiarity