Student or Learner
In the below sentence what is appropriate? Is or Was ?
“Could you please advise me if there was/is an opportunity available at this stage?”
If the answer is WAS then please tell me why IS not correct since this the sentence is in present tense?