Soft Enquiry will be mostly immediate. Hard Enquiry will take from days to months, so cibil score will not go down immediately if at all.
But some do hard enquiries immediately, so depends on the bank.. For me indusind, Hdfc reflected after 2-3 mths.. Sbi, amex were in the same month